[dbo].[Component_Script

Property	Value
Created	10:31:17 AM Tuesday, March 02, 2010
Last Modified	11:40:01 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_Component_Script_Ref: ComponentCode\ComponentScriptCode$	ComponentCode	char(2)	2
$Cluster Primary Key PK_Component_Script_Ref: ComponentCode\ComponentScriptCode$	ComponentScriptCode	char(2)	2
	ComponentScriptDesc	varchar(100)	100
	ParameterScript	varchar(255)	255
	ParameterFormScript	varchar(255)	255
	NewScript	varchar(255)	255
	ShortListScript	varchar(255)	255
	FullListScript	varchar(255)	255
	PublishScript	varchar(255)	255
	DisplayScript	varchar(255)	255
	ShowInTemplateFlag	char(1)	1
	SendSectionFlag	char(1)	1
	AspNetFlag	char(1)	1	('N')
	SubComponentCode	char(2)	2
	EditScript	varchar(255)	255

	Name	Columns	Unique
$Cluster Primary Key PK_Component_Script_Ref: ComponentCode\ComponentScriptCode$	PK_Component_Script_Ref	ComponentCode, ComponentScriptCode

Name	Columns
FK_ComponentScript_Component	ComponentCode->[dbo].[Component_Ref].[ComponentCode]

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Component_Script_Ref]
(
[ComponentCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ComponentScriptCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ComponentScriptDesc] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParameterScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParameterFormScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NewScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShortListScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FullListScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PublishScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DisplayScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShowInTemplateFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SendSectionFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AspNetFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Component_Script_Ref_AspNetFlag] DEFAULT ('N'),
[SubComponentCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EditScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Component_Script_Ref] ADD CONSTRAINT [PK_Component_Script_Ref] PRIMARY KEY CLUSTERED ([ComponentCode], [ComponentScriptCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Component_Script_Ref] ADD CONSTRAINT [FK_ComponentScript_Component] FOREIGN KEY ([ComponentCode]) REFERENCES [dbo].[Component_Ref] ([ComponentCode])
GO
GRANT REFERENCES ON  [dbo].[Component_Script_Ref] TO [IMIS]
GRANT SELECT ON  [dbo].[Component_Script_Ref] TO [IMIS]
GRANT INSERT ON  [dbo].[Component_Script_Ref] TO [IMIS]
GRANT DELETE ON  [dbo].[Component_Script_Ref] TO [IMIS]
GRANT UPDATE ON  [dbo].[Component_Script_Ref] TO [IMIS]
GO